UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZtLoP0MMSfuQvYJb5Rkyjou4Kgtu6LTaN81ZOV03Rdw='
WHERE
key_id = '1fb9f74932183b9124ce19a66b95ee467de502feead653a43866fd02b915815e'
AND (
token = 'ZtLoP0MMSfuQvYJb5Rkyjou4Kgtu6LTaN81ZOV03Rdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)