UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3i7GkzyFkF8fnJj40a6N4nWeOs2/0X5s2xSiDyl79II='
WHERE
key_id = 'e8973948973ac2f4bb98c4738e358c4413b54b478e23c870c50ff4117a58084a'
AND (
token = '3i7GkzyFkF8fnJj40a6N4nWeOs2/0X5s2xSiDyl79II='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)