UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1MHPgwYnTyFShVYKrV21lyQIuz+DM4/x04B4XaLZe04='
WHERE
key_id = '2794a419c4d841d3a529f15f2dee86b25600f5c267b3731623353349559789ec'
AND (
token = '1MHPgwYnTyFShVYKrV21lyQIuz+DM4/x04B4XaLZe04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)