UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KwzbJsuxlYgH+ISeOnKc9zftj/VGmndlVo9GDxd3Lao='
WHERE
key_id = '0cf7d99aba862da39644bfec8825f7a2d96053b205adc64d995de8fb6762166b'
AND (
token = 'KwzbJsuxlYgH+ISeOnKc9zftj/VGmndlVo9GDxd3Lao='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)